package cn.edu.ujn.finallab.dao;

import java.util.HashMap;
import java.util.List;


public interface RoomMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(Room record);

    int insertSelective(Room record);

    Room selectByPrimaryKey(Integer id);
    
    Room selectByNumber(String number);
    
    List<Room> selectAllRoom();

    int updateByPrimaryKeySelective(Room record);

    int updateByPrimaryKey(Room record);
    
    int selectRoomCount();
    
    List<Room> selectByPageLimit(HashMap<String, Object> map);
    
    int deleteByPrimaryKey(int id);
    
    List<Room> selectUnreservedRoomByTypeAndPrice(HashMap<String, Object> map);
    
    List<Room> selectReservedRoomByTypeAndPrice(HashMap<String, Object> map);
    
    //查询对应类型的客房总数
    int selectRoomCountByRoomType(String roomtype);
    
    List<Room> selectByPageLimitByRoomType(HashMap<String, Object> map);
}